package com.abc.db;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

public class DBHelper extends SQLiteOpenHelper {

	private static final String DATABASE_NAME = "easyclaim.db";
	private static final int DATABASE_VERSION = 1;
	public DBHelper(Context context) {
		//CursorFactory设置为null,使用默认值
		super(context, DATABASE_NAME, null, DATABASE_VERSION);
	}

	//数据库第一次被创建时onCreate会被调用,创建数据库结构
	@Override
	public void onCreate(SQLiteDatabase db) {
		
		db.execSQL("CREATE TABLE IF NOT EXISTS caze" +
				"(id INTEGER PRIMARY KEY AUTOINCREMENT, name VARCHAR, accidentDate DATETIME, accidentAddress VARCHAR,lastModifyDate DATETIME,carNumber VARCHAR,carOwnerName VARCHAR,carOwnerPhone VARCHAR,carOwnerAddr VARCHAR,insuranceNumber VARCHAR,note VARCHAR,officerName VARCHAR,officerNumber VARCHAR)");
	}

	//如果DATABASE_VERSION值被改为2,系统发现现有数据库版本不同,即会调用onUpgrade
	@Override
	public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
		db.execSQL("drop table if exists caze");
		onCreate(db);
	}
}
